package com.puris.service.admin;

import com.puris.pojo.Admin;

import java.sql.SQLException;
import java.sql.Date;

/**
 * @author Sonata
 * @data 2021/11/26 18:49
 */
public interface Service {
    public Admin login(String id, String password);

    public StringBuffer selectStudent() throws SQLException;
    public boolean addStudent(String id, String department, int grade, String className, String studentName) throws SQLException;
    public StringBuffer findStudent(String id) throws SQLException;
    public boolean updateStudent(String id, String department, int grade, String className, String studentName) throws SQLException;
    public boolean deleteStudent(String id) throws SQLException;

    public StringBuffer selectTeacher() throws SQLException;
    public boolean addTeacher(String id, String department, String teacherName, String competitionName) throws SQLException;
    public StringBuffer findTeacher(String id) throws SQLException;
    public boolean updateTeacher(String id, String department, String teacherName, String competitionName) throws SQLException;
    public boolean deleteTeacher(String id) throws SQLException;

    public StringBuffer selectCompetition() throws SQLException;
    public boolean addCompetition(String id, String competitionName, Date date, String describe, String teacherId, String teacherName) throws SQLException;
    public StringBuffer findCompetition(String id) throws SQLException;
    public boolean updateCompetition(String id, String competitionName, Date date, String describe, String teacherId, String teacherName) throws SQLException;
    public boolean deleteCompetition(String id) throws SQLException;
}
